![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
EnhancementsSome additional enhancements may help improve the performance of your batch processing system. A few of the items that can help are listed here; the list also includes some enhancements that will not help performance. Each item is accompanied by an explanation.
Many of these enhancements can help performance in a batch system. I recommend the use of the Oracle Parallel Query option, if at all possible. The specific effect on your system will vary, but most of the hints in this chapter work well for most situations. Parallel Query OptionA DSS or batch processing system is probably the best application to take advantage of the Parallel Query option. The design of the Parallel Query option is centered around large queries that access large amounts of data, as is typical of both DSS and batch processing systems. Here is a short list of some of the operations that can be parallelized:
Depending on your application, you may use one or more of these transaction types. Because these queries are typically long running and involve large amounts of disk I/O, you can drastically cut the time it takes to complete these queries with the use of the Parallel Query option. Once you set up a test database and develop some test queries (hopefully similar to, if not exactly like production queries), run these queries with various degrees of parallelism to determine optimal performance. Because batch jobs are often very repeatable, any tuning changes that are beneficial in your test environment are often just as beneficial in production. The Parallel Query option can take advantage of the concurrent nature of disk arrays. By splitting up the queries into many small pieces, you may be able to request data from all the drives in your system simultaneously, optimizing I/O performance. Oracle Parallel Server OptionThe Oracle Parallel Server option may be very beneficial to your batch processing system in two ways:
The Oracle Parallel Server option can enhance the performance of your batch processing systembut only if queries can be divided among the different systems in the cluster. In general, I do not think that the Oracle Parallel Server option is particularly useful in a batch processing system. Parallel server clusters are better suited for OLTP or decision support systems.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |